Performance modeling of nested transactions in database systems
نویسندگان
چکیده
The nested transaction model was introduced to satisfy the requirements of advanced database applications. Moreover, it is currently the basic transaction model for new databases like workflow systems, mobile databases, and objectrelational databases. Though there are several performance evaluation studies of different concurrency control mechanisms in nested transactions, effects of transaction parameters on the overall system performance have not received any attention. In this paper, we study the effects of transactions characteristics on system performance. We developed a detailed simulation model and conducted several experiments to measure the impact of transactions characteristics on the performance. First, the effect of the number of leaves on the performance of nested transactions is investigated under different shaping parameters. Also, effects of the depth of the transaction tree on the system performance are investigated.
منابع مشابه
Performance Evaluation of Nested Transactions on Locally Distributed Database Systems
This paper describes an execution time estimating model for nested transactions running on locally distributed database systems. At rst the model of nested transactions and the model of a locally distributed database system are established. The performance evaluation model of nested transactions is then built in three steps. The rst step describes a nondeterministic algorithm that evaluates the...
متن کاملEffects of shaping characteristics on the performance of nested transactions
The nested transaction model was introduced to satisfy the requirements of advanced database applications. Moreover, it is currently the basic transaction model for new database applications like work¯ow systems and new database systems like mobile databases and object-relational databases. Though there are several performance evaluation studies of different concurrency control mechanisms in ne...
متن کاملEnhancing the Success Ratio of Distributed Real-Time Nested Transactions
The traditional transaction models are not suited to real-time database systems (RTDBSs). Indeed, many current applications managed by these systems necessitate a kind of transactions where some of the ACID properties must be ignored or adapted. In this paper, we propose a real-time concurrency control protocol and an adaptation of the Two-Phase Commit Protocol based on the nested transaction m...
متن کاملTransactional Correctness for Secure Nested Transactions
Secure Nested Transactions are an adaptation of traditional nested transactions to support the synergy of language-based security and multi-level database security. They have application in security for enterprise applications, where transactional semantics are a critical feature in middleware systems. This article considers correctness in terms of transactional properties for secure nested tra...
متن کاملNested Transactions with Multiple Commit Points: an Approach to the Structuring of Advance0 Database Applications
A new type of transactions for higher level applfcation programing in systems with databases is introduced. These so-called 'nested transactions with multiple commit points' support operations over multiple applications either atomically, fndependent, or in a combination of both. Furthermore, it is strictly distinguished between transactions as units of work and transactions as a part of so-cal...
متن کامل